'use strict';

module.exports = app => {
  const { DataTypes } = app.Sequelize;

  const Demo = app.model.define('just_demo', {
    id: { type: DataTypes.UUID, defaultValue: DataTypes.UUIDV4, primaryKey: true },
    name: { allowNull: false, type: DataTypes.STRING(100) },
    region: { allowNull: true, type: DataTypes.STRING(100) },
    imgs: { allowNull: true, type: DataTypes.STRING(1500) },
    date1: {
      allowNull: true,
      type: DataTypes.DATE,
      defaultValue: DataTypes.NOW,
      get () {
        return this.getDataValue('date1')
        // return parseTime(this.getDataValue('date1'));
      }
    },
    date2: {
      allowNull: true,
      type: DataTypes.DATE,
      get () {
        return this.getDataValue('date2')
        // return parseTime(this.getDataValue('date2'));
      }
    },
    delivery: { allowNull: true, type: DataTypes.BOOLEAN, allowNull: false, defaultValue: false, comment: '是否配送: 1 配送； 0 不配送' },
    classify: { allowNull: true, type: DataTypes.STRING(200) },
    resource: { allowNull: true, type: DataTypes.STRING(200) },
    remarks: { allowNull: true, type: DataTypes.STRING(100) },
  });
  return Demo;

};


function parseTime (time, cFormat) {
  if (arguments.length === 0 || !time) {
    return null;
  }
  const format = cFormat || '{y}-{m}-{d} {h}:{i}:{s}';
  let date;
  if (typeof time === 'object') {
    date = time;
  } else {
    if ((typeof time === 'string')) {
      if ((/^[0-9]+$/.test(time))) {
        // support "1548221490638"
        time = parseInt(time);
      } else {
        // support safari
        // https://stackoverflow.com/questions/4310953/invalid-date-in-safari
        time = time.replace(new RegExp(/-/gm), '/');
      }
    }

    if ((typeof time === 'number') && (time.toString().length === 10)) {
      time = time * 1000;
    }
    date = new Date(time);
  }
  const formatObj = {
    y: date.getFullYear(),
    m: date.getMonth() + 1,
    d: date.getDate(),
    h: date.getHours(),
    i: date.getMinutes(),
    s: date.getSeconds(),
    a: date.getDay(),
  };
  const time_str = format.replace(/{([ymdhisa])+}/g, (result, key) => {
    const value = formatObj[key];
    // Note: getDay() returns 0 on Sunday
    if (key === 'a') { return ['日', '一', '二', '三', '四', '五', '六'][value]; }
    return value.toString().padStart(2, '0');
  });
  return time_str;
}

